====== SQL Query Plugin ======

---- plugin ----
description: Processing query to MySQL databases and display results as a table.
author     : George P.
email      : digitalduke@gmail.com
type       : syntax
lastupdate : 2019-05-03
compatible : Elenor Of Tsort, Frusterick Manners, Greebo
depends    : 
conflicts  : 
similar    : 
tags       : database, mysql, sql, query

sourcerepo : https://github.com/digitalduke/sqlquery
bugtracker : https://github.com/digitalduke/sqlquery/issues
downloadurl: https://github.com/digitalduke/sqlquery/archive/1.0.zip
donationurl: https://www.buymeacoffee.com/digitalduke
----

===== Description =====

Do you want to display data from your MySQL database in DokuWiki? No problem! This simple plugin processing query to MySQL database and displaying results as a table. You also may use it with [[plugin:datatables|DataTables Plugin]] for more usability such as -- sorting, searching and etc.

Please [[https://www.buymeacoffee.com/digitalduke|donate]] if you like it.

===== Syntax =====

Basic syntax:

  <sql>query string</sql>

  * ''query string'' -- SQL query to perform against the database.


===== Examples =====

Perform a simple query to display all records from the table "table":

  <sql>select * from table;</sql>

Using together with [[plugin:datatables|DataTables Plugin]]:

  <datatables>
  <sql>select * from table;</sql>
  </datatables>


===== Configuration and Settings =====

The plugin can be configured via the [[:plugin:config|Configuration Manager]]

^ Option  ^ Description  ^ Default value ^
| Host     | DNS name or IP address of MySQL server | localhost |
| DB       | MySQL database name | (empty) |
| user     | MySQL user name | (empty) |
| password | MySQL password | (empty) |


===== Change Log =====

  * **2019-05-03**
    * Successfully tested with "Frusterick Manners" and "Greebo" latest releases.
  * **2016-11-25**
    * Initial release


===== Discussion, feature requests and bug reports =====

[[https://github.com/digitalduke/sqlquery/issues|Issues in project repository]]